package com.test1.mybatis.study.mapper;

import com.test1.mybatis.study.model.ArticleInfo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface ArticleInfoMapper {
    @Select("select ta.*,tb.username,tb.age,tb.gender from articleinfo ta left join userinfo tb on " + "ta.uid = tb.id"+
            " where ta.id = #{id}")
    ArticleInfo queryArticleInfo(Integer id);
}
